﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace Movie.DAL
{
   public  class RoomDAl
    {
       public static Modal.Room GetRoom(int RoomID) 
       {
           string sql = "select * from Room where RoomId="+RoomID;
           SqlDataReader reder = sqlHelper2.ExcuteReader(sql);
           Modal.Room room = null;
           if (reder.Read())
           {
               room = new Modal.Room();
               room.CinemaID=Convert.ToInt32(reder["CinemaID"]);
               room.RoomID = RoomID;
               room.Name = reder["Name"].ToString();
           }
           return room;
       
       }
    }
}
